CREATE EXTERNAL TABLE ai_dw.yl_ml_clean_address_day(
                                                       `id` string COMMENT 'md5ID',
                                                       `update_time` timestamp COMMENT '更新时间',
                                                       `receiver_province_id` int COMMENT '省份id',
                                                       `receiver_province_name` string COMMENT '省份名称',
                                                       `receiver_city_id` int COMMENT '市ID分区',
                                                       `receiver_city_name` string COMMENT '城市名称',
                                                       `receiver_area_id` int COMMENT '区域Id',
                                                       `receiver_area_name` string COMMENT '区域名称',
                                                       `receiver_township` string COMMENT '乡镇',
                                                       `receiver_street` string COMMENT '街道',
                                                       `receiver_detailed_address` string COMMENT '详细地址',
                                                       `receiver_full_address` string COMMENT '全地址',
                                                       `network_id` int COMMENT '网点id',
                                                       `network_code` string COMMENT '网点code',
                                                       `network_name` string COMMENT '网点名称',
                                                       `staff_code` string COMMENT '员工CODE',
                                                       `staff_name` string COMMENT '员工名称',
                                                       `first_code` string COMMENT '一段码',
                                                       `second_code` string COMMENT '二段码',
                                                       `third_code` string COMMENT '三段码',
                                                       `longitude_geo` double COMMENT '经度geo',
                                                       `latitude_geo` double COMMENT '纬度geo',
                                                       `longitude_poi` double COMMENT '经度poi',
                                                       `latitude_poi` double COMMENT '纬度poi',
                                                       `change_flag` int COMMENT '变更标识 ：1变化，0未变化',
                                                       `change_time` string COMMENT '网点围栏更新时间',
                                                       `last_sign_time` timestamp COMMENT '派件签收时间',
                                                       `sign_province_id` int COMMENT '签收网点省份id',
                                                       `sign_province_name` string COMMENT '签收网点省份名称',
                                                       `sign_city_id` int COMMENT '签收网点城市id',
                                                       `sign_city_name` string COMMENT '签收网点城市名称',
                                                       `sign_area_id` int COMMENT '签收网点区域Id',
                                                       `sign_area_name` string COMMENT '签收网点区域名称',
                                                       `sign_full_address` string COMMENT '签收网点全地址',
                                                       `address_library_checked` int COMMENT '判断是否已在地址库存在',
                                                       `address_library_source` int COMMENT '地址库来源',
                                                       `town_id` int COMMENT '街道级别id',
                                                       `geo_coordinate` string COMMENT '高德爬取的geo经纬度',
                                                       `poi_coordinate` string COMMENT '高德爬取的POI经纬度',
                                                       `waybill_no` string COMMENT '运单ID',
                                                       `sign_finance_name` string COMMENT '代理区名称',
                                                       `sign_finance_code` string COMMENT '代理区code',
                                                       `city_id` int COMMENT '签收网点城市id',
                                                       `pick_network_code` string COMMENT '寄件网点code',
                                                       `waybill_province_id` int COMMENT '运单省份id',
                                                       `waybill_province_name` string COMMENT '运单省份名称',
                                                       `waybill_city_id` int COMMENT '运单市ID分区',
                                                       `waybill_city_name` string COMMENT '运单城市名称',
                                                       `waybill_area_id` int COMMENT '运单区域Id',
                                                       `waybill_area_name` string COMMENT '运单区域名称',
                                                       `waybill_detailed_address` string COMMENT '运单详细地址',
                                                       `waybill_full_address` string COMMENT '运单全地址',
                                                       `is_addr_equal` int comment '订单运单地址是否相等：1相等2不等')
    COMMENT '干净的地址表'
    PARTITIONED BY (`dt` string COMMENT '日期分区')
    ROW FORMAT SERDE
        'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
    STORED AS INPUTFORMAT
        'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
        OUTPUTFORMAT
            'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
    LOCATION
        '/dw/hive/ai_dw.db/external/yl_ml_clean_address_day'